var nodeXlsx = require('node-xlsx');
var excelData = nodeXlsx.parse('./routes/20160818/20160818.xlsx');
var arr = [];
var l = excelData.length;
for (var i = 0; i < l; i++) {
    var ar = excelData[i].data;
    var ll = ar.length;
    for (var j = 1; j < ll; j++) {
        var aa = ar[j];
        arr.push({
            country: aa[0] == 'underfine' ? '' : aa[0],
            symbol: aa[1] == 'underfine' ? '' : aa[1],
            name_cn: aa[2] == 'underfine' ? '' : aa[2],
            etf_type: aa[3] == 'underfine' ? '' : aa[3],
            go_long: aa[4] == 'underfine' ? '' : aa[4],
            is_lever: aa[5] == 'underfine' ? '' : aa[5],
            is_hedging: aa[6] == 'underfine' ? '' : aa[6],
            investingUrl: aa[7] == 'underfine' ? '' : aa[7],
            id: aa[8] == 'underfine' ? '' : aa[8]
        });
    }
}
module.exports = arr;

